/opt/module/sqoop/bin/sqoop export \
--connect "jdbc:mysql://node101:3306/mzy?useUnicode=true&characterEncoding=utf-8" \
--username root \
--password 123456  \
--table ads_user_proportion \
--export-dir /user/spark/warehouse/jtp_ads_warehouse/ads_user_proportion \
--update-mode allowinsert \
--fields-terminated-by '\001' \
--input-null-non-string '\\N' \
--input-null-string '\\N' \
--num-mappers 1

/opt/module/sqoop/bin/sqoop export \
--connect "jdbc:mysql://node101:3306/mzy?useUnicode=true&characterEncoding=utf-8" \
--username root \
--password 123456  \
--table ads_user_gender \
--export-dir /user/spark/warehouse/jtp_ads_warehouse/ads_user_gender \
--update-mode allowinsert \
--fields-terminated-by '\001' \
--input-null-non-string '\\N' \
--input-null-string '\\N' \
--num-mappers 1

/opt/module/sqoop/bin/sqoop export \
--connect "jdbc:mysql://node101:3306/mzy?useUnicode=true&characterEncoding=utf-8" \
--username root \
--password 123456  \
--table ads_user_new \
--export-dir /user/spark/warehouse/jtp_ads_warehouse/ads_user_new \
--update-mode allowinsert \
--fields-terminated-by '\001' \
--input-null-non-string '\\N' \
--input-null-string '\\N' \
--num-mappers 1\

/opt/module/sqoop/bin/sqoop export \
--connect "jdbc:mysql://node101:3306/mzy?useUnicode=true&characterEncoding=utf-8" \
--username root \
--password 123456  \
--table ads_product_count \
--export-dir /user/spark/warehouse/jtp_ads_warehouse/ads_product_count \
--update-mode allowinsert \
--fields-terminated-by '\001' \
--input-null-non-string '\\N' \
--input-null-string '\\N' \
--num-mappers 1

/opt/module/sqoop/bin/sqoop export \
--connect "jdbc:mysql://node101:3306/mzy?useUnicode=true&characterEncoding=utf-8" \
--username root \
--password 123456  \
--table ads_pay_count \
--export-dir /user/spark/warehouse/jtp_ads_warehouse/ads_pay_count \
--update-mode allowinsert \
--fields-terminated-by '\001' \
--input-null-non-string '\\N' \
--input-null-string '\\N' \
--num-mappers 1

/opt/module/sqoop/bin/sqoop export \
--connect "jdbc:mysql://node101:3306/mzy?useUnicode=true&characterEncoding=utf-8" \
--username root \
--password 123456  \
--table ads_product_information \
--export-dir /user/spark/warehouse/jtp_ads_warehouse/ads_product_information \
--update-mode allowinsert \
--fields-terminated-by '\001' \
--input-null-non-string '\\N' \
--input-null-string '\\N' \
--num-mappers 1